package com.cqupt.mant_to_many;

import com.cqupt.bean.Student;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface StudentMapper {
    @Select("SELECT s.id,s.name,s.age,s.`cid` FROM student s,course c,stu_cr sc WHERE s.id = sc.sid AND sc.cid = c.id AND sc.cid = #{id}")
    public List<Student> selectStudent(Integer id);
}
